<?php
$con = mysql_connect('localhost','root','');
$db = mysql_select_db('paradigmShift_DEV');
if(isset($_GET['id']))
{
    $sql = "SELECT * FROM roledate r, employees e,roles ro WHERE r.roleID=ro.roleID AND r.empID = e.empID and r.id = ".$_GET['id'];
    $result = mysql_query($sql);
    print_r(json_encode(mysql_fetch_assoc($result)));
}
?>
